/*
 Navicat Premium Data Transfer

 Source Server         : local
 Source Server Type    : MySQL
 Source Server Version : 50140
 Source Host           : localhost
 Source Database       : arnetminer

 Target Server Type    : MySQL
 Target Server Version : 50140
 File Encoding         : utf-8

 Date: 08/22/2011 09:43:31 AM
*/

SET NAMES utf8;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
--  Table structure for `comment`
-- ----------------------------
DROP TABLE IF EXISTS `comment`;
CREATE TABLE `comment` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `comment` text NOT NULL,
  `postDate` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `user_id` int(11) NOT NULL,
  `status_id` int(11) NOT NULL,
  PRIMARY KEY (`id`),
  KEY `user_id` (`user_id`),
  KEY `status_id` (`status_id`)
) ENGINE=MyISAM AUTO_INCREMENT=102 DEFAULT CHARSET=utf8;

-- ----------------------------
--  Records of `comment`
-- ----------------------------
BEGIN;
INSERT INTO `comment` VALUES ('1', 'Well....', '2011-07-03 23:46:56', '1', '35'), ('2', 'OMG...', '2011-07-03 23:48:54', '1', '36'), ('3', 'Yahoo~', '2011-07-03 23:54:11', '1', '36'), ('4', 'GOGO...', '2011-07-04 00:00:06', '1', '36'), ('5', ':)', '2011-07-04 00:02:28', '1', '23'), ('6', 'Hello~', '2011-07-04 00:06:34', '1', '23'), ('7', 'haha~', '2011-07-04 00:07:07', '1', '36'), ('8', 'Nice~', '2011-07-04 00:14:58', '1', '33'), ('51', 'Hey~', '2011-07-07 22:50:07', '1', '57'), ('11', 'Yes!', '2011-07-04 00:18:57', '1', '33'), ('12', 'HAHA~', '2011-07-04 00:21:09', '1', '32'), ('13', ':)', '2011-07-04 00:33:47', '1', '37'), ('14', ':)', '2011-07-04 00:34:08', '1', '37'), ('15', '^_^', '2011-07-04 00:34:57', '1', '37'), ('16', '*_*', '2011-07-04 00:35:31', '1', '37'), ('17', 'How are you?', '2011-07-04 00:37:51', '1', '37'), ('18', ':)', '2011-07-04 00:38:08', '1', '37'), ('19', 'hehe', '2011-07-04 00:38:37', '1', '36'), ('20', 'DOD', '2011-07-04 00:39:57', '1', '36'), ('21', 'Mi Mi Mi...', '2011-07-04 00:41:39', '1', '38'), ('22', ':P', '2011-07-04 00:45:34', '1', '37'), ('23', ':P', '2011-07-04 00:46:02', '1', '39'), ('24', 'hh', '2011-07-04 00:47:11', '1', '39'), ('25', ':)', '2011-07-04 00:47:31', '1', '39'), ('26', ':)', '2011-07-04 00:50:26', '1', '42'), ('27', 'Baidu~', '2011-07-04 00:53:21', '1', '45'), ('28', 'lol', '2011-07-04 00:53:54', '1', '46'), ('29', 'LOL', '2011-07-04 00:54:19', '1', '46'), ('30', 'right?', '2011-07-04 00:55:03', '1', '47'), ('31', '~~~~~', '2011-07-04 00:55:38', '1', '48'), ('32', 'Linux', '2011-07-04 00:56:59', '1', '49'), ('33', 'Leopard...', '2011-07-04 01:00:37', '1', '50'), ('34', 'Just', '2011-07-04 01:01:54', '1', '51'), ('35', 'Snow...', '2011-07-04 01:02:37', '1', '50'), ('36', 'CBA', '2011-07-04 01:05:32', '1', '52'), ('37', 'qqqqq', '2011-07-04 01:07:09', '1', '53'), ('38', 'Really?', '2011-07-04 01:08:22', '1', '54'), ('50', 'Hoho~', '2011-07-07 21:41:09', '1', '33'), ('40', 'SURE', '2011-07-04 01:54:10', '1', '57'), ('48', 'You are right~', '2011-07-04 02:30:10', '1', '57'), ('42', '*_*', '2011-07-04 01:56:10', '1', '58'), ('43', 'Hello~', '2011-07-04 02:16:13', '1', '55'), ('44', 'Is it true?', '2011-07-04 02:16:33', '1', '31'), ('46', 'Joke a~', '2011-07-04 02:26:02', '1', '58'), ('47', 'Fine...', '2011-07-04 02:29:57', '1', '58'), ('49', 'Really?', '2011-07-04 02:30:30', '1', '31'), ('52', 'HEIHEI~', '2011-07-07 23:46:39', '1', '58'), ('53', ':)', '2011-07-11 17:48:56', '1', '58'), ('54', 'Holly~', '2011-07-11 18:13:43', '1', '58'), ('55', 'Hello~', '2011-07-11 18:15:56', '1', '58'), ('56', ':)', '2011-07-14 21:43:19', '1', '67'), ('63', 'haha', '2011-08-07 10:06:02', '1', '75'), ('79', ':)', '2011-08-07 14:16:11', '1', '75'), ('81', 'Hello~', '2011-08-07 14:17:42', '5', '74'), ('101', 'Good!', '2011-08-08 00:04:56', '1', '73'), ('100', 'Welcome!', '2011-08-08 00:01:36', '1', '75'), ('99', 'Good!', '2011-08-07 23:59:55', '1', '75'), ('97', '&lt;br/&gt;', '2011-08-07 19:06:52', '9', '73'), ('96', ':(', '2011-08-07 19:06:46', '9', '73'), ('95', 'hoho', '2011-08-07 19:06:39', '9', '73'), ('98', ':)', '2011-08-07 22:11:05', '1', '75');
COMMIT;

-- ----------------------------
--  Table structure for `event`
-- ----------------------------
DROP TABLE IF EXISTS `event`;
CREATE TABLE `event` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `postDate` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00' ON UPDATE CURRENT_TIMESTAMP,
  `type_id` int(11) NOT NULL,
  `subId` int(11) NOT NULL,
  `eventId` int(11) NOT NULL,
  PRIMARY KEY (`id`),
  KEY `type` (`type_id`)
) ENGINE=MyISAM AUTO_INCREMENT=15 DEFAULT CHARSET=utf8;

-- ----------------------------
--  Records of `event`
-- ----------------------------
BEGIN;
INSERT INTO `event` VALUES ('1', '2011-07-12 22:32:15', '1', '5', '63'), ('2', '2011-07-13 21:56:29', '1', '5', '64'), ('3', '2011-07-13 21:56:37', '1', '5', '65'), ('4', '2011-07-13 22:24:06', '1', '5', '66'), ('5', '2011-07-13 22:35:37', '1', '5', '67'), ('6', '2011-07-13 22:39:38', '1', '1', '68'), ('7', '2011-07-14 21:43:42', '1', '5', '69'), ('8', '2011-07-14 21:43:54', '1', '5', '70'), ('9', '2011-07-14 21:43:54', '1', '5', '71'), ('10', '2011-07-14 21:44:00', '1', '5', '72'), ('11', '2011-07-14 21:44:04', '1', '5', '73'), ('12', '2011-08-04 21:32:36', '1', '1', '74'), ('13', '2011-08-06 00:01:56', '1', '5', '75'), ('14', '2011-08-07 15:08:44', '1', '9', '76');
COMMIT;

-- ----------------------------
--  Table structure for `eventType`
-- ----------------------------
DROP TABLE IF EXISTS `eventType`;
CREATE TABLE `eventType` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `type` varchar(50) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=4 DEFAULT CHARSET=utf8;

-- ----------------------------
--  Records of `eventType`
-- ----------------------------
BEGIN;
INSERT INTO `eventType` VALUES ('1', 'status'), ('2', 'local'), ('3', 'arnetminer');
COMMIT;

-- ----------------------------
--  Table structure for `follow`
-- ----------------------------
DROP TABLE IF EXISTS `follow`;
CREATE TABLE `follow` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `follower` int(11) NOT NULL,
  `followee` int(11) NOT NULL,
  `type_id` int(11) NOT NULL,
  PRIMARY KEY (`id`),
  KEY `follower` (`follower`)
) ENGINE=MyISAM AUTO_INCREMENT=43 DEFAULT CHARSET=utf8;

-- ----------------------------
--  Records of `follow`
-- ----------------------------
BEGIN;
INSERT INTO `follow` VALUES ('42', '1', '8', '1'), ('11', '1', '2', '1'), ('12', '5', '1', '1'), ('41', '1', '6', '1'), ('40', '1', '5', '1'), ('15', '1', '3', '1'), ('16', '2', '1', '1'), ('17', '1', '4', '1');
COMMIT;

-- ----------------------------
--  Table structure for `followType`
-- ----------------------------
DROP TABLE IF EXISTS `followType`;
CREATE TABLE `followType` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `type` varchar(50) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=5 DEFAULT CHARSET=utf8;

-- ----------------------------
--  Records of `followType`
-- ----------------------------
BEGIN;
INSERT INTO `followType` VALUES ('1', 'local'), ('2', 'author'), ('3', 'publication'), ('4', 'conference');
COMMIT;

-- ----------------------------
--  Table structure for `message`
-- ----------------------------
DROP TABLE IF EXISTS `message`;
CREATE TABLE `message` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `sender` int(11) NOT NULL,
  `receiver` int(11) NOT NULL,
  `title` varchar(50) NOT NULL,
  `content` text NOT NULL,
  `sendDate` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `isPrivate` int(1) NOT NULL,
  `isDraft` int(1) NOT NULL,
  `isRead` int(1) NOT NULL,
  `inOrout` int(1) NOT NULL,
  PRIMARY KEY (`id`),
  KEY `sender` (`sender`),
  KEY `receiver` (`receiver`)
) ENGINE=MyISAM AUTO_INCREMENT=13 DEFAULT CHARSET=utf8;

-- ----------------------------
--  Records of `message`
-- ----------------------------
BEGIN;
INSERT INTO `message` VALUES ('1', '1', '5', 'GOGO', ':)', '2011-08-21 15:30:51', '0', '0', '1', '1'), ('2', '1', '5', 'GOGO', ':)', '2011-08-21 15:30:51', '0', '0', '1', '0'), ('3', '1', '5', 'Where r u?', 'rt', '2011-08-21 15:32:09', '0', '0', '1', '1'), ('4', '1', '5', 'Where r u?', 'rt', '2011-08-21 15:32:09', '0', '0', '1', '0'), ('5', '1', '5', 'wawa', 'wawa', '2011-08-21 15:32:23', '0', '0', '1', '1'), ('6', '1', '5', 'wawa', 'wawa', '2011-08-21 15:32:23', '0', '0', '1', '0'), ('7', '5', '1', 'back', 'Back!', '2011-08-21 15:52:46', '0', '0', '1', '1'), ('8', '5', '1', 'back', 'Back!', '2011-08-21 15:52:46', '0', '0', '1', '0'), ('9', '1', '5', 'HELLO A', '&gt;_&lt;', '2011-08-21 21:35:35', '0', '0', '1', '1'), ('10', '1', '5', 'HELLO A', '&gt;_&lt;', '2011-08-21 21:35:35', '0', '0', '1', '0'), ('11', '1', '5', 'Hello', ':)', '2011-08-21 23:49:01', '0', '0', '0', '1'), ('12', '1', '5', 'Hello', ':)', '2011-08-21 23:49:01', '0', '0', '1', '0');
COMMIT;

-- ----------------------------
--  Table structure for `notification`
-- ----------------------------
DROP TABLE IF EXISTS `notification`;
CREATE TABLE `notification` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `notifiee` int(11) NOT NULL,
  `event_id` int(11) NOT NULL,
  PRIMARY KEY (`id`),
  KEY `notifiee` (`notifiee`),
  KEY `event` (`event_id`)
) ENGINE=MyISAM AUTO_INCREMENT=31 DEFAULT CHARSET=utf8;

-- ----------------------------
--  Records of `notification`
-- ----------------------------
BEGIN;
INSERT INTO `notification` VALUES ('6', '2', '4'), ('5', '9', '4'), ('28', '1', '13'), ('8', '9', '5'), ('9', '2', '5'), ('10', '5', '6'), ('12', '9', '7'), ('13', '2', '7'), ('15', '9', '8'), ('16', '2', '8'), ('30', '5', '11'), ('18', '9', '9'), ('19', '2', '9'), ('29', '1', '13'), ('21', '9', '10'), ('22', '2', '10'), ('23', '1', '11'), ('24', '9', '11'), ('25', '2', '11'), ('26', '5', '12'), ('27', '2', '12');
COMMIT;

-- ----------------------------
--  Table structure for `organization`
-- ----------------------------
DROP TABLE IF EXISTS `organization`;
CREATE TABLE `organization` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `orgName` varchar(100) NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `org_name` (`orgName`)
) ENGINE=MyISAM AUTO_INCREMENT=7 DEFAULT CHARSET=utf8;

-- ----------------------------
--  Records of `organization`
-- ----------------------------
BEGIN;
INSERT INTO `organization` VALUES ('1', 'Indiana University'), ('2', 'TsingHua University'), ('3', 'Peking University'), ('4', 'Shandong University'), ('5', 'Houston'), ('6', 'Pfizer');
COMMIT;

-- ----------------------------
--  Table structure for `security`
-- ----------------------------
DROP TABLE IF EXISTS `security`;
CREATE TABLE `security` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `password` varchar(50) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=13 DEFAULT CHARSET=utf8;

-- ----------------------------
--  Records of `security`
-- ----------------------------
BEGIN;
INSERT INTO `security` VALUES ('1', 'F84774A373CF7210268528A6FE846C15'), ('2', 'F84774A373CF7210268528A6FE846C15'), ('3', 'F84774A373CF7210268528A6FE846C15'), ('4', 'F84774A373CF7210268528A6FE846C15'), ('6', 'F84774A373CF7210268528A6FE846C15'), ('7', 'F84774A373CF7210268528A6FE846C15'), ('8', 'F84774A373CF7210268528A6FE846C15'), ('9', 'F84774A373CF7210268528A6FE846C15'), ('10', 'F84774A373CF7210268528A6FE846C15'), ('11', 'F84774A373CF7210268528A6FE846C15'), ('12', 'F84774A373CF7210268528A6FE846C15');
COMMIT;

-- ----------------------------
--  Table structure for `source`
-- ----------------------------
DROP TABLE IF EXISTS `source`;
CREATE TABLE `source` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `type` varchar(50) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=3 DEFAULT CHARSET=utf8;

-- ----------------------------
--  Records of `source`
-- ----------------------------
BEGIN;
INSERT INTO `source` VALUES ('1', 'local'), ('2', 'arnetminer');
COMMIT;

-- ----------------------------
--  Table structure for `status`
-- ----------------------------
DROP TABLE IF EXISTS `status`;
CREATE TABLE `status` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `status` text NOT NULL,
  `postDate` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `user_id` int(11) NOT NULL,
  PRIMARY KEY (`id`),
  KEY `user_id` (`user_id`)
) ENGINE=MyISAM AUTO_INCREMENT=77 DEFAULT CHARSET=utf8;

-- ----------------------------
--  Records of `status`
-- ----------------------------
BEGIN;
INSERT INTO `status` VALUES ('1', 'Hello World!', '2011-07-02 18:52:37', '1'), ('20', 'Hibernate....', '2011-07-03 11:03:39', '1'), ('3', 'ArnetMiner....', '2011-07-02 21:24:54', '1'), ('22', 'Struts....', '2011-07-03 11:05:40', '1'), ('21', 'Spring....', '2011-07-03 11:04:22', '1'), ('8', 'Monday Tuesday...', '2011-07-02 23:44:06', '1'), ('32', 'ArnetMiner~~~~', '2011-07-03 14:05:36', '5'), ('11', 'What\'s in your mind...', '2011-07-02 23:46:21', '1'), ('23', 'I want to be a billionaire...', '2011-07-03 11:06:06', '1'), ('33', 'Lovely day...', '2011-07-03 14:12:19', '5'), ('17', 'Can you feel my world...', '2011-07-02 23:50:06', '1'), ('18', 'Hello~~', '2011-07-03 00:10:54', '5'), ('31', '&lt;a href=&quot;http://www.google.com&quot;&gt;Google&lt;/a&gt;', '2011-07-03 13:58:40', '5'), ('35', 'Well, well, well~', '2011-07-03 22:48:43', '1'), ('36', 'LOL~', '2011-07-03 23:47:18', '1'), ('37', 'Hello a~', '2011-07-04 00:31:48', '1'), ('38', 'Do Do Do...', '2011-07-04 00:41:28', '1'), ('39', ':P', '2011-07-04 00:45:57', '1'), ('40', '*_*', '2011-07-04 00:48:03', '1'), ('41', '(_)', '2011-07-04 00:49:00', '1'), ('42', 'la la la~', '2011-07-04 00:50:21', '1'), ('43', 'wo wo wo~', '2011-07-04 00:51:23', '1'), ('44', 'Judy~', '2011-07-04 00:52:27', '1'), ('45', 'Google~', '2011-07-04 00:53:17', '1'), ('46', 'Post your status here...', '2011-07-04 00:53:47', '1'), ('47', '1 1 = 2', '2011-07-04 00:54:56', '1'), ('48', '-----', '2011-07-04 00:55:33', '1'), ('49', 'Red Hat', '2011-07-04 00:56:56', '1'), ('50', 'Mac OS', '2011-07-04 01:00:31', '1'), ('51', 'Final...', '2011-07-04 01:01:51', '1'), ('52', 'NBA', '2011-07-04 01:05:28', '1'), ('53', 'ppppp', '2011-07-04 01:07:04', '1'), ('54', 'Last time...', '2011-07-04 01:08:16', '1'), ('55', 'Yuyin Sun', '2011-07-04 01:50:49', '1'), ('56', ':)', '2011-07-04 01:51:52', '1'), ('57', 'OKAY', '2011-07-04 01:54:07', '1'), ('58', ':(', '2011-07-04 01:55:43', '1'), ('59', 'Monday~', '2011-07-11 18:01:07', '5'), ('60', ':)', '2011-07-11 18:16:01', '1'), ('61', 'Hello~', '2011-07-12 22:08:46', '5'), ('62', 'New Event!!', '2011-07-12 22:20:14', '5'), ('63', ':)', '2011-07-12 22:32:15', '5'), ('64', ':)', '2011-07-13 21:56:29', '5'), ('65', 'Noti!!', '2011-07-13 21:56:37', '5'), ('66', 'New notification!', '2011-07-13 22:24:06', '5'), ('67', 'Wednesday!', '2011-07-13 22:35:37', '5'), ('69', '*_*', '2011-07-14 21:43:42', '5'), ('70', '|_|', '2011-07-14 21:43:54', '5'), ('71', 'Status saved...', '2011-07-14 21:43:54', '5'), ('72', 'lalala~', '2011-07-14 21:44:00', '5'), ('73', '555~', '2011-07-14 21:44:04', '5'), ('74', 'Test', '2011-08-04 21:32:36', '1'), ('75', ':)', '2011-08-06 00:01:56', '5'), ('76', 'New Link~', '2011-08-07 15:08:44', '9');
COMMIT;

-- ----------------------------
--  Table structure for `user`
-- ----------------------------
DROP TABLE IF EXISTS `user`;
CREATE TABLE `user` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `email` varchar(50) NOT NULL,
  `firstName` varchar(20) NOT NULL,
  `lastName` varchar(20) NOT NULL,
  `thumb` varchar(100) NOT NULL DEFAULT 'images/thumb.jpg',
  `org_id` int(11) NOT NULL,
  `source_id` int(11) NOT NULL,
  `secure_id` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `email` (`email`),
  KEY `org_id` (`org_id`),
  KEY `source_id` (`source_id`),
  KEY `secure_id` (`secure_id`)
) ENGINE=MyISAM AUTO_INCREMENT=12 DEFAULT CHARSET=utf8;

-- ----------------------------
--  Records of `user`
-- ----------------------------
BEGIN;
INSERT INTO `user` VALUES ('1', 'yuysun@indiana.edu', 'Yuyin', 'Sun', 'images/pam/thumb.jpg', '1', '1', '1'), ('2', 'dido@pku.edu.cn', 'Dido', 'Chen', 'images/pam/thumb.jpg', '3', '1', '2'), ('3', 'wgao@pfizer.com', 'Wei', 'Gao', 'images/pam/thumb.jpg', '6', '1', '3'), ('4', 'bryce@pfizer.com', 'Bryce', 'Li', 'images/pam/thumb.jpg', '6', '1', '4'), ('5', 'nyu@indiana.edu', 'Ning', 'Yu', 'images/pam/thumb.jpg', '1', '1', '6'), ('6', 'eyan@indiana.edu', 'Erjia', 'Yan', 'images/pam/thumb.jpg', '1', '1', '7'), ('7', 'nde@sdu.edu.cn', 'Delei', 'Nie', 'images/pam/thumb.jpg', '4', '1', '8'), ('8', 'weng@indiana.edu', 'Lillian', 'Weng', 'images/pam/thumb.jpg', '1', '1', '9'), ('9', 'chni@indiana.edu', 'Chaoqun', 'Ni', 'images/pam/thumb.jpg', '1', '1', '10'), ('10', 'joe@indiana.edu', 'Joe', 'Cole', 'images/pam/thumb.jpg', '1', '1', '11'), ('11', 'cecilia@indiana.edu', 'Cecilia', 'Lun', 'images/pam/thumb.jpg', '1', '1', '12');
COMMIT;

